Hi

We are using excel export as pdf functionality and have the following DCOM configuration

1.start->run and type 'DCOMCNFG'

2: Open 'DCOM Config' and locate 'Microsoft Excel Application'

3: Set its identity to 'This User' and give specific service user

On opening excel  we are getting  "cannot use object linking and embedding error" and the microsoft sugestions tells to change to launching user which is not an option for us,Is there any other suggestion to fix this issue by keeping Dcom configuration with'This User'

Thanks in advance

Pradeep

Hi

when excel is opened, a warning pops up saying "Cannot use object linking and embedding" . This fix change the DCOM ID to Launching User) does not work for us. We need the Excel DCOM ID to use a particular user "domain\user" in order to access excel from our website.

Is there any other suggestions

Thanks in advance

Pradeep

• Merged by Fei XueMicrosoft contingent staff 8 hours 45 minutes ago same topic

Hi

when excel is opened, a warning pops up saying "Cannot use object linking and embedding" . This fix change the DCOM ID to Launching User) does not work for us. We need the Excel DCOM ID to use a particular user "domain\user" in order to access excel from our website.

Is there any other suggestions

Thanks in advance

Pradeep

• Merged by Fei XueMicrosoft contingent staff Thursday, February 12, 2015 3:07 AM same topic

Hi,

I am experiencing the same problem. A pipeline is creating/deplyoing a new database, and we want to update a template .xlsx to point to the newly created database. The pipeline is build using SSIS, updating the .xlsx is done by a Powershell-script running a VBA-macro within the .xlsx.

We're running Office 2013 on Windows Server 2012.

I checked and re-configured:

1. DCOM-settings
2. non-interactive heapsize in the registry HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems
3. folders including security settings: C:\Windows\SysWOW64\config (\systemprofile)

But all to no avail. Any tips & tricks are welcome!

• Edited by proverbs53 15 hours 33 minutes ago layout